FileMaker Pro Relational Databases

Outcomes

In this course, you will learn powerful techniques for developing complex database systems containing multiple linked database files. You will learn about the various relationship types, link databases together, use field formatting options, and will create buttons and scripts to create a system that is ultimately easy and efficient for an end user to work with.

Prerequisites

FileMaker Pro 5 Basic Skills, or equivalent knowledge.

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

Advanced Field and Layout Options Advanced Field Definitions Creating a New Database Defining Fields Defining Fields with Serial Number Auto Entry Defining Fields with Date Auto Entry Defining Value Lists Defining Repeating Fields Creating Efficient Layouts Arranging Fields on the Layout Formatting Repeating Fields Formatting Value Lists on a Layout Making Final Layout Adjustments Manually Entering Record Data Importing Records Importing Records from Other Files Relating Databases Introduction to Relations Relationship Types and Terminology Examining Database Files Working with One-to-Many Relationships Defining Relationships Placing Related Fields on a Layout Defining a Bi-Directional Relationship Creating a Layout to Display Related Records from the "Many"File Creating a Portal to Display Related Records Viewing Related Records with a Portal

Many-to-Many Relationships Establishing Many-to-Many Relationships Creating an Intermediate Database Defining Many-to-Many Relationships Displaying Related Fields in a "Bridge" Database Entering Information into the "Bridge" Database Utilizing Related Data Creating a Portal to Access Related Information in a Many-to-ManyRelationship Defining Calculation Fields to Bridge a Many-to-Many Relationship Creating a Portal to View Registrations Summarizing Portal Records Creating a Count of Students Enhancing Portals Setting Up a Relationship to Allow the Creation of RelatedRecords Creating a Value List from Another File Allowing the Deletion of Related Records Scripts and Buttons Creating Simple Buttons Creating a Button that Adds a New Record Creating a Button to Go to a Related Record Scripting Creating a Script that Includes Find Requests Creating the Final Script Layout Creating a Script to Go to Related Records Creating a Script to Omit Records Creating a Script to Switch Layouts and Print Chaining Scripts Combining Scripts and Buttons Attaching a Script to a Button Suppressing the Printing of an Object

Performance-based objectives

• Use advanced field definitions including calculation fields.
• Apply auto-entry, value lists, and other field options to make data entry easier and more efficient.
• Create efficient layouts that include repeating fields, portals, and merge fields.
• Identify the three types of data relationships, and use them to build a relational database system.
• Create buttons on a layout to execute commands and scripts.
• Create scripts to quickly recall and execute a simple or complex series of steps.